CREATE TRIGGER TGNXB_01 ON NHAXUATBAN
INSTEAD OF DELETE
AS
BEGIN
	DECLARE @MANXB VARCHAR(15)
	SET @MANXB = (SELECT MANHAXUATBAN FROM deleted)
	DELETE FROM SachNhaXuatBan WHERE MaNhaXuatBan = @MANXB
	DELETE FROM NhaXuatBan WHERE MaNhaXuatBan = @MANXB
END